An Elastic Multi-Core Allocation Mechanism for Database Systems

During the parallel execution of queries in Non-Uniform Memory Access (NUMA) systems, he Operating System (OS) maps the threads (or processes) from modern database systems to the available cores among the NUMA nodes using the standard node-local policy. However, such non-smart mapping may result in inefficient memory activity, because shared data may be accessed by scattered threads requiring large data movements or non-shared data may be allocated to threads sharing the same cache memory, increasing its conflicts. In this paper we present a data-distribution aware and elastic multi-core allocation mechanism to improve the OS mapping of database threads in NUMA systems. Our hypothesis is that we mitigate the data movement if we only hand out to the OS the local optimum number of cores in specific nodes. We propose a mechanism based on a rule-condition-action pipeline that uses hardware counters to promptly find out the local optimum number of cores. Our mechanism uses a priority queue to track the history of the memory address space used by database threads in order to decide about the allocation/release of cores and its distribution among the NUMA nodes to decrease remote memory access. We implemented and tested a prototype of our mechanism when executing two popular Volcano-style databases improving their NUMA-affinity. For MonetDB, we show maximum speedup of 1.53 × , due to consistent reduction in the local/remote per-query data traffic ratio of up to 3.87 × running 256 concurrent clients in the 1 GB TPC-H database also showing system energy savings of 26.05%. For the NUMA-aware SQL Server, we observed speedup of up to 1.27 × and reduction on the data traffic ratio of 3.70 ×

Bayesian spatio-temporal models for mapping TB mortality risk and its relationship with social inequities in a region from Brazilian Legal Amazon

publishersversionpublishe

Search for supersymmetry in events with b-quark jets and missing transverse energy in pp collisions at 7 TeV

Results are presented from a search for physics beyond the standard model based on events with large missing transverse energy, at least three jets, and at least one, two, or three b-quark jets. The study is performed using a sample of proton-proton collision data collected at sqrt(s) = 7 TeV with the CMS detector at the LHC in 2011. The integrated luminosity of the sample is 4.98 inverse femtobarns. The observed number of events is found to be consistent with the standard model expectation, which is evaluated using control samples in the data. The results are used to constrain cross sections for the production of supersymmetric particles decaying to b-quark-enriched final states in the context of simplified model spectra.Comment: Submitted to Physical Review

Validation of reference genes for expression analysis in the salivary gland and the intestine of Rhodnius prolixus (Hemiptera, Reduviidae) under different experimental conditions by quantitative real-time PCR

<p>Abstract</p> <p>Background</p> <p><it>Rhodnius prolixus </it>is a blood-feeding insect that can transmit <it>Trypanosoma cruzi </it>and <it>Trypanosoma rangeli </it>to vertebrate hosts. Recently, genomic resources for invertebrate vectors of human pathogens have increased significantly, and <it>R. prolixus </it>has been one of the main species studied among the triatomines. However, the paucity of information on many of the fundamental molecular aspects of this species limits the use of the available genomic information. The present study aimed to facilitate gene expression studies by identifying the most suitable reference genes for the normalization of mRNA expression data from qPCR.</p> <p>Results</p> <p>The expression stability of five candidate reference genes (<it>18S </it>rRNA, <it>GAPDH</it>, β-actin, α-tubulin and ribosomal protein <it>L26</it>) was evaluated by qPCR in two tissues (salivary gland and intestine) and under different physiological conditions: before and after blood feeding and after infection with <it>T. cruzi </it>or <it>T. rangeli</it>. The results were analyzed with three software programs: geNorm, NormFinder and BestKeeper. All of the evaluated candidate genes proved to be acceptable as reference genes, but some were found to be more appropriate depending on the experimental conditions. <it>18S</it>, <it>GAPDH </it>and α-tubulin showed acceptable stability for studies in all of the tissues and experimental conditions evaluated. β-actin, one of the most widely used reference genes, was confirmed to be one of the most suitable reference genes in studies with salivary glands, but it had the lowest expression stability in the intestine after insect blood feeding. <it>L26 </it>was identified as the poorest reference gene in the studies performed.</p> <p>Conclusions</p> <p>The expression stability of the genes varies in different tissue samples and under different experimental conditions. The results provided by three statistical packages emphasize the suitability of all five of the tested reference genes in both the crop and the salivary glands with a few exceptions. The results emphasise the importance of validating reference genes for qRT-PCR analysis in <it>R. prolixus </it>studies.</p

Planck 2018 results. XII. Galactic astrophysics using polarized dust emission

We present 353 GHz full-sky maps of the polarization fraction $p$, angle $\psi$, and dispersion of angles $S$ of Galactic dust thermal emission produced from the 2018 release of Planck data. We confirm that the mean and maximum of $p$ decrease with increasing $N_H$. The uncertainty on the maximum polarization fraction, $p_\mathrm{max}=22.0$% at 80 arcmin resolution, is dominated by the uncertainty on the zero level in total intensity. The observed inverse behaviour between $p$ and $S$ is interpreted with models of the polarized sky that include effects from only the topology of the turbulent Galactic magnetic field. Thus, the statistical properties of $p$, $\psi$, and $S$ mostly reflect the structure of the magnetic field. Nevertheless, we search for potential signatures of varying grain alignment and dust properties. First, we analyse the product map $S \times p$, looking for residual trends. While $p$ decreases by a factor of 3--4 between $N_H=10^{20}$ cm$^{-2}$ and $N_H=2\times 10^{22}$ cm$^{-2}$, $S \times p$ decreases by only about 25%, a systematic trend observed in both the diffuse ISM and molecular clouds. Second, we find no systematic trend of $S \times p$ with the dust temperature, even though in the diffuse ISM lines of sight with high $p$ and low $S$ tend to have colder dust. We also compare Planck data with starlight polarization in the visible at high latitudes. The agreement in polarization angles is remarkable. Two polarization emission-to-extinction ratios that characterize dust optical properties depend only weakly on $N_H$ and converge towards the values previously determined for translucent lines of sight. We determine an upper limit for the polarization fraction in extinction of 13%, compatible with the $p_\mathrm{max}$ observed in emission. These results provide strong constraints for models of Galactic dust in diffuse gas